﻿CREATE TABLE [dbo].[UDS_Flow_Style_Description] (
    [Description_ID]    int           NOT NULL identity(1, 1),
    [Style_ID]          int           NULL,
    [Field_Name]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Field_Description] nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Judged]            bit           NULL,
    [MultiLine]         bit           NULL,
    [Height]            int           NULL,
    [Width]             int           NULL,
    [Position]          int           NULL,
    [Example]           nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,

    CONSTRAINT [PK_UDS_Flow_Style_Description] PRIMARY KEY NONCLUSTERED (Description_ID asc),
    CONSTRAINT [FK_UDS_Flow_Style_Description_Style_ID] FOREIGN KEY (Style_ID) REFERENCES dbo.UDS_Flow_Style (Style_ID) ON DELETE CASCADE
);
CREATE UNIQUE CLUSTERED INDEX [IX_UDS_Flow_Style_Description_Style_Field] ON dbo.[UDS_Flow_Style_Description] (Style_ID asc, Field_Name asc);
GO
